microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

microsoft excel q/a PRACTICE TEST [13 - EXERCISES]

MS excel set 1

MS excel set 2

MS excel set 3

MS excel set 4

MS excel set 5

MS excel set 6

MS excel set 7

MS excel set 8

MS excel set 9

MS excel set 10

MS excel set 11

MS excel set 12

MS excel set 13

Question : 26

In Excel AutoCalculate will quickly add selected cells if you

a) right click on the status bar and select Sum

b) click the AutoCalculate button on the toolbar

c) use the key combination Ctrl+$

d) double click the selection

Discuss »

Answer: (b)

Question : 27

The Trace Dependence in auditing shows

a) Which cells are used in current formula

b) In which formula the current cell is used

c) Which cells are used in this formula and in which formula this cell is used

d) All of above

e) None of these

Discuss »

Answer: (b)

Question : 28

You can use the formula palette to

a) format cells containing numbers

b) create and edit formulas containing functions

c) entered assumptions data

d) copy a range of cells

e) None of these

Discuss »

Answer: (b)

Question : 29

The default and maximum number of sheets for a new workbook in Excel 2003 is

a) 3 and 255

b) 3 and 256

c) 1 and 255

d) 1 and 256

e) None of these

Discuss »

Answer: (b)

Question : 30

In Excel using the AutoSum button will replace in the selected cell

a) the sum of values in the cell’s column

b) nothing until you select a range of cells

c) the sum of the cell’s row unless you change the range

d) a formula which will add values in the range Excel guesses you want to add

Discuss »

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 12 Online Quiz

Click to Start..
418 microsoft excel qa based computer MCQ MS excel set 12 question answer with explanation pdf
microsoft excel q/a Shortcuts and Techniques with Examples
computer MCQ CATEGORIES
RECENT BLOGS
SSC CHSL Exam Centres 2023 Tier 1 & 2: State-Wise Apply Link
SSC CHSL Exam Centres 2023 Tier 1 & 2: State-Wise Apply Link Read more...
SSC CHSL 2023 Tier 2: Syllabus PDF & Exam Pattern [Changed]
SSC CHSL 2023 Tier 2: Syllabus PDF & Exam Pattern [Changed] Read more...
SSC CHSL Tier 1 Revised Syllabus 2023 & New Topics List PDF
SSC CHSL Tier 1 Revised Syllabus 2023 & New Topics List PDF Read more...
SSC CHSL 2023 Tier 2 New Revised Exam Pattern & Syllabus PDF
SSC CHSL 2023 Tier 2 New Revised Exam Pattern & Syllabus PDF Read more...

Recently Added Subject & Categories For All Competitive Exams

100+ Quadratic Equation Questions Answers PDF for Bank

Quadratic Equation multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

IBPS Aptitude Linear Equations MCQ Questions Answers PDF

Linear equations multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

New 100+ Compound Interest MCQ with Answers PDF for IBPS

Compound Interest verbal ability questions and answers solutions with PDF for IBPS RRB PO. Aptitude Objective MCQ Practice Exercises all competitive exams

02-Jul-2024 by Careericons

Continue Reading »

100+ Mixture and Alligation MCQ Questions PDF for IBPS

Most importantly Mixture and Alligation multiple choice questions and answers with PDF for IBPS RRB PO. Aptitude MCQ Practice Exercises all Bank Exams

02-Jul-2024 by Careericons

Continue Reading »